<?php

require_once dirname(__FILE__) . '/../lib/techospresupuestariosGeneratorConfiguration.class.php';
require_once dirname(__FILE__) . '/../lib/techospresupuestariosGeneratorHelper.class.php';

/**
 * techospresupuestarios actions.
 *
 * @package    SistemaWebUnlSenescyt
 * @subpackage techospresupuestarios
 * @author     JFernando
 * @version    SVN: $Id: actions.class.php 23810 2009-11-12 11:07:44Z Kris.Wallsmith $
 */
class techospresupuestariosActions extends sfActions {

    public function preExecute() {
        $this->configuration = new techospresupuestariosGeneratorConfiguration();

        if (!$this->getUser()->hasCredential($this->configuration->getCredentials($this->getActionName()))) {
            $this->forward(sfConfig::get('sf_secure_module'), sfConfig::get('sf_secure_action'));
        }

        $this->dispatcher->notify(new sfEvent($this, 'admin.pre_execute', array('configuration' => $this->configuration)));

        $this->helper = new techospresupuestariosGeneratorHelper();

        parent::preExecute();
    }

    public function executeIndex(sfWebRequest $request) {
        // sorting
        if ($request->getParameter('sort') && $this->isValidSortColumn($request->getParameter('sort'))) {
            $this->setSort(array($request->getParameter('sort'), $request->getParameter('sort_type')));
        }

        // pager
        if ($request->getParameter('page')) {
            $this->setPage($request->getParameter('page'));
        }

        $this->pager = $this->getPager();
        $this->sort = $this->getSort();
    }

    public function executeFilter(sfWebRequest $request) {
        $this->setPage(1);

        if ($request->hasParameter('_reset')) {
            $this->setFilters($this->configuration->getFilterDefaults());

            $this->redirect('@techospresupuestarios');
        }

        $this->filters = $this->configuration->getFilterForm($this->getFilters());

        $this->filters->bind($request->getParameter($this->filters->getName()));
        if ($this->filters->isValid()) {
            $this->setFilters($this->filters->getValues());

            $this->redirect('@techospresupuestarios');
        }

        $this->pager = $this->getPager();
        $this->sort = $this->getSort();

        $this->setTemplate('index');
    }

    public function executeNew(sfWebRequest $request) {
        $this->form = $this->configuration->getForm();
        $this->techospresupuestarios = $this->form->getObject();
    }

    public function executeCreate(sfWebRequest $request) {
        $this->form = $this->configuration->getForm();
        $this->techospresupuestarios = $this->form->getObject();

        $this->processForm($request, $this->form);

        $this->setTemplate('new');
    }

    public function executeEdit(sfWebRequest $request) {
        $this->techospresupuestarios = $this->getRoute()->getObject();
        $this->form = $this->configuration->getForm($this->techospresupuestarios);
    }

    public function executeUpdate(sfWebRequest $request) {
        $this->techospresupuestarios = $this->getRoute()->getObject();
        $this->form = $this->configuration->getForm($this->techospresupuestarios);

        $this->processFormEdit($request, $this->form);

        $this->setTemplate('edit');
    }

    public function executeDelete(sfWebRequest $request) {
        $request->checkCSRFProtection();

        $this->dispatcher->notify(new sfEvent($this, 'admin.delete_object', array('object' => $this->getRoute()->getObject())));

        if ($this->getRoute()->getObject()->delete()) {
            $this->getUser()->setFlash('notice', 'El Techo Presupuestario fue eliminado exitosamente');
        }

        $this->redirect('@techospresupuestarios');
    }

    public function executeBatch(sfWebRequest $request) {
        $request->checkCSRFProtection();

        if (!$ids = $request->getParameter('ids')) {
            $this->getUser()->setFlash('error', 'You must at least select one item.');

            $this->redirect('@techospresupuestarios');
        }

        if (!$action = $request->getParameter('batch_action')) {
            $this->getUser()->setFlash('error', 'You must select an action to execute on the selected items.');

            $this->redirect('@techospresupuestarios');
        }

        if (!method_exists($this, $method = 'execute' . ucfirst($action))) {
            throw new InvalidArgumentException(sprintf('You must create a "%s" method for action "%s"', $method, $action));
        }

        if (!$this->getUser()->hasCredential($this->configuration->getCredentials($action))) {
            $this->forward(sfConfig::get('sf_secure_module'), sfConfig::get('sf_secure_action'));
        }

        $validator = new sfValidatorDoctrineChoice(array('multiple' => true, 'model' => 'techospresupuestarios'));
        try {
            // validate ids
            $ids = $validator->clean($ids);

            // execute batch
            $this->$method($request);
        } catch (sfValidatorError $e) {
            $this->getUser()->setFlash('error', 'A problem occurs when deleting the selected items as some items do not exist anymore.');
        }

        $this->redirect('@techospresupuestarios');
    }

    protected function executeBatchDelete(sfWebRequest $request) {
        $ids = $request->getParameter('ids');

        $records = Doctrine_Query::create()
                ->from('techospresupuestarios')
                ->whereIn('id_tp', $ids)
                ->execute();

        foreach ($records as $record) {
            $this->dispatcher->notify(new sfEvent($this, 'admin.delete_object', array('object' => $record)));

            $record->delete();
        }

        $this->getUser()->setFlash('notice', 'The selected items have been deleted successfully.');
        $this->redirect('@techospresupuestarios');
    }

    function checkText($text) {
        $pattern = "/^[á é í ó ú Á É Í Ó Ú Ñ ñ A-Z a-z' ']+$/i";
        if (preg_match($pattern, $text)) {
            return true;
        } else {
            return false;
        }
    }

    protected function processForm(sfWebRequest $request, sfForm $form) {
        $form->bind($request->getParameter($form->getName()), $request->getFiles($form->getName()));
        if ($form->isValid()) {


            try {
                try {
                    $techospresupuestarios = $form->save();
                    if ($this->checkText($techospresupuestarios->getNombre()) == false) {

                        $techospresupuestarios->delete();
                        $this->getUser()->setFlash('error', 'Solo se permiten letras en el nombre del techo presupuestario');
                        $this->redirect('@techospresupuestarios_new');
                    } else {
                        $this->getUser()->setFlash('notice', 'Techo Presupuestario agregado exitosamente.');
                        //$this->redirect('@techospresupuestarios');
                        //$notice = $form->getObject()->isNew() ? 'Techo Presupuestario agregado exitosamente.' : 'Techo Presupuestario agregado exitosamente.exitosamente.';
                    }
                } catch (Exception $e) {
                    $this->getUser()->setFlash('error', 'Error en ingreso de datos incompatibilidad');
                }
            } catch (Doctrine_Validator_Exception $e) {

                $errorStack = $form->getObject()->getErrorStack();

                $message = get_class($form->getObject()) . ' has ' . count($errorStack) . " field" . (count($errorStack) > 1 ? 's' : null) . " with validation errors: ";
                foreach ($errorStack as $field => $errors) {
                    $message .= "$field (" . implode(", ", $errors) . "), ";
                }
                $message = trim($message, ', ');

                $this->getUser()->setFlash('error', $message);
                return sfView::SUCCESS;
            }

            //$this->dispatcher->notify(new sfEvent($this, 'admin.save_object', array('object' => $techospresupuestarios)));

            if ($request->hasParameter('_save_and_add')) {
                $this->getUser()->setFlash('notice', $notice . ' You can add another one below.');

                $this->redirect('@techospresupuestarios_new');
            } else {
                //$this->getUser()->setFlash('notice', $notice);
                //$this->redirect(array('sf_route' => 'techospresupuestarios_edit', 'sf_subject' => $techospresupuestarios));
            }
        } else {
            $this->getUser()->setFlash('error', 'Ya existe un techo presupuestario con este nombre.', false);
        }
    }

//    function clear_cache($app, $env) {
//        $cacheDir = sfConfig::get('sf_cache_dir') . '/' . $app . '/' . $env . '/';
//
//        //Eliminamos la cache
//        $cache = new sfFileCache(array('cache_dir' => $cacheDir));
//        $cache->clean();
//    }

    protected function processFormEdit(sfWebRequest $request, sfForm $form) {
        $form->bind($request->getParameter($form->getName()), $request->getFiles($form->getName()));
        if ($form->isValid()) {


            try {
                try {
                    $techospresupuestarios = $form->save();
                    if ($this->checkText($techospresupuestarios->getNombre()) == false) {


                        $this->getUser()->setFlash('error', 'Solo se permiten letras en el nombre del techo presupuestario');
                    } else {
//                        $app = sfConfig::get('app_sf_app');
//                        $env = sfConfig::get('app_sf_environment');
//                        $this->clear_cache($app, $env);
                        $this->getUser()->setFlash('notice', 'Techo Presupuestario modificado exitosamente.');

                        //$this->redirect('@techospresupuestarios');
                        //$notice = $form->getObject()->isNew() ? 'Techo Presupuestario agregado exitosamente.' : 'Techo Presupuestario agregado exitosamente.exitosamente.';
                    }
                } catch (Exception $e) {
//                    $app = sfConfig::get('app_sf_app');
//                    $env = sfConfig::get('app_sf_environment');
//                    $this->clear_cache($app, $env);
                    $this->getUser()->setFlash('error', 'Error en ingreso de datos incompatibilidad');
                }
            } catch (Doctrine_Validator_Exception $e) {

                $errorStack = $form->getObject()->getErrorStack();

                $message = get_class($form->getObject()) . ' has ' . count($errorStack) . " field" . (count($errorStack) > 1 ? 's' : null) . " with validation errors: ";
                foreach ($errorStack as $field => $errors) {
                    $message .= "$field (" . implode(", ", $errors) . "), ";
                }
                $message = trim($message, ', ');

                $this->getUser()->setFlash('error', $message);
                return sfView::SUCCESS;
            }

            //$this->dispatcher->notify(new sfEvent($this, 'admin.save_object', array('object' => $techospresupuestarios)));

            if ($request->hasParameter('_save_and_add')) {
                $this->getUser()->setFlash('notice', $notice . ' You can add another one below.');

                $this->redirect('@techospresupuestarios_new');
            } else {
                //$this->getUser()->setFlash('notice', $notice);
                //$this->redirect(array('sf_route' => 'techospresupuestarios_edit', 'sf_subject' => $techospresupuestarios));
            }
        } else {
            $this->getUser()->setFlash('error', 'Ya existe un techo presupuestario con este nombre.', false);
        }
    }

    protected function getFilters() {
        return $this->getUser()->getAttribute('techospresupuestarios.filters', $this->configuration->getFilterDefaults(), 'admin_module');
    }

    protected function setFilters(array $filters) {
        return $this->getUser()->setAttribute('techospresupuestarios.filters', $filters, 'admin_module');
    }

    protected function getPager() {
        $pager = $this->configuration->getPager('techospresupuestarios');
        $pager->setQuery($this->buildQuery());
        $pager->setPage($this->getPage());
        $pager->init();

        return $pager;
    }

    protected function setPage($page) {
        $this->getUser()->setAttribute('techospresupuestarios.page', $page, 'admin_module');
    }

    protected function getPage() {
        return $this->getUser()->getAttribute('techospresupuestarios.page', 1, 'admin_module');
    }

    protected function buildQuery() {
        $tableMethod = $this->configuration->getTableMethod();
        if (null === $this->filters) {
            $this->filters = $this->configuration->getFilterForm($this->getFilters());
        }

        $this->filters->setTableMethod($tableMethod);

        $query = $this->filters->buildQuery($this->getFilters());

        $this->addSortQuery($query);

        $event = $this->dispatcher->filter(new sfEvent($this, 'admin.build_query'), $query);
        $query = $event->getReturnValue();

        return $query;
    }

    protected function addSortQuery($query) {
        if (array(null, null) == ($sort = $this->getSort())) {
            return;
        }

        if (!in_array(strtolower($sort[1]), array('asc', 'desc'))) {
            $sort[1] = 'asc';
        }

        $query->addOrderBy($sort[0] . ' ' . $sort[1]);
    }

    protected function getSort() {
        if (null !== $sort = $this->getUser()->getAttribute('techospresupuestarios.sort', null, 'admin_module')) {
            return $sort;
        }

        $this->setSort($this->configuration->getDefaultSort());

        return $this->getUser()->getAttribute('techospresupuestarios.sort', null, 'admin_module');
    }

    protected function setSort(array $sort) {
        if (null !== $sort[0] && null === $sort[1]) {
            $sort[1] = 'asc';
        }

        $this->getUser()->setAttribute('techospresupuestarios.sort', $sort, 'admin_module');
    }

    protected function isValidSortColumn($column) {
        return Doctrine_Core::getTable('techospresupuestarios')->hasColumn($column);
    }

}
